<!DOCTYPE html>
<html>
<head data-suburl="">
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<meta http-equiv="X-UA-Compatible" content="IE=edge"/>
	
		<meta name="author" content="diogo" />
		<meta name="description" content="gnu-social - GNU social is a social communication software used in federated social networks. It is widely supported and has a large userbase. It is already used by the Free Software Foundation." />
		<meta name="keywords" content="go, git, self-hosted, gogs">
	
	<meta name="referrer" content="no-referrer" />
	<meta name="_csrf" content="xIEQVyCx7PtAPR5PACovdhABItA6MTYwNDc5MjM1MTg5ODE3Njc2NQ==" />
	<meta name="_suburl" content="" />
	
	
	
		<meta property="og:url" content="https://notabug.org/diogo/gnu-social" />
		<meta property="og:type" content="object" />
		<meta property="og:title" content="diogo/gnu-social">
		<meta property="og:description" content="GNU social is a social communication software used in federated social networks. It is widely supported and has a large userbase. It is already used by the Free Software Foundation.">
		<meta property="og:image" content="https://notabug.org/avatars/12290" />
	

	<link rel="shortcut icon" href="/img/favicon.png" />

	<script src="/js/jquery-1.11.3.min.js"></script>
	<script src="/js/libs/jquery.are-you-sure.js"></script>
        <link href="/img/icon-48.ico" rel="icon" type="image/x-icon" />
        <link href="/img/icon-60.png" rel="apple-touch-icon">
        <link href="/img/icon-76.png" rel="apple-touch-icon" sizes="76x76">
        <link href="/img/icon-120.png" rel="apple-touch-icon" sizes="120x120">
        <link href="/img/icon-152.png" rel="apple-touch-icon" sizes="152x152">
        <link href="/img/icon-240.png" rel="apple-touch-icon" sizes="240x240">

	<link rel="stylesheet" href="/assets/font-awesome-4.6.3/css/font-awesome.min.css">
	<link rel="stylesheet" href="/assets/octicons-4.3.0/octicons.min.css">

	
	

	

	
	<link rel="stylesheet" href="/css/semantic-2.2.13.min.css">
	<link rel="stylesheet" href="/css/gogs.css?v=6fc9e85aa88133794d3434ea74aa557a">
	<link rel="stylesheet" href="/css/notabug.css">

	
	<script src="/js/semantic-2.2.13.min.js"></script>
	<script src="/js/gogs.js?v=6fc9e85aa88133794d3434ea74aa557a"></script>

	<title>RFC: Restructuring the database - NotABug.org: Free code hosting</title>

	<meta name="theme-color" content="#428bca">

	


<noscript><style>.nojs-popup:hover > .menu { display: block ; }</style></noscript>


</head>
<body>
	<div class="full height">
		<noscript>Please enable JavaScript in your browser!</noscript>

		
			<div id="header-div" class="following bar light">
				<div class="ui container">
					<div class="ui grid">
						<div class="column">
							<div class="ui top secondary menu">
								<a class="item brand" href="/">
									<img class="ui mini image" src="/img/favicon.png">
								</a>

								
									<a class="item" href="/">Home</a>
								

								<a class="item" href="/explore/repos">Explore</a>
								

								



									<a class="notabug-item item" href="/help" rel="noreferrer">Help</a>




									<div class="right menu">
										
											<a class="item" href="/user/sign_up">
												<i class="octicon octicon-person"></i> Register
											</a>
										
										<a class="item" href="/user/login?redirect_to=%2fdiogo%2fgnu-social%2fissues%2f163">
											<i class="octicon octicon-sign-in"></i> Sign In
										</a>
									</div>

								
							</div>
						</div>
					</div>
				</div>
			</div>
		


<div class="repository view issue pull">
	<div class="header-wrapper">

	<div class="ui container">
		<div class="ui vertically padded grid head">
			<div class="column">
				<div class="ui header">
					<div class="ui huge breadcrumb">
						<i class="mega-octicon octicon-repo"></i>
						<a href="/diogo">diogo</a>
						<div class="divider"> / </div>
						<a href="/diogo/gnu-social">gnu-social</a>
						
						
					</div>

					
						<div class="ui right">
							<div class="ui labeled button" tabindex="0">
								<a class="ui basic button" href="/diogo/gnu-social/action/watch?redirect_to=%2fdiogo%2fgnu-social%2fissues%2f163">
									<i class="icon fa-eye-slash"></i>Watch
								</a>
								<a class="ui basic label" href="/diogo/gnu-social/watchers">
									9
								</a>
							</div>
							<div class="ui labeled button" tabindex="0">
								<a class="ui basic button" href="/diogo/gnu-social/action/star?redirect_to=%2fdiogo%2fgnu-social%2fissues%2f163">
									<i class="icon fa-star-o"></i>Star
								</a>
								<a class="ui basic label" href="/diogo/gnu-social/stars">
									22
								</a>
							</div>
							
								<div class="ui labeled button" tabindex="0">
									<a class="ui basic button " href="/repo/fork/25974">
										<i class="octicon octicon-repo-forked"></i>Fork
									</a>
									<a class="ui basic label" href="/diogo/gnu-social/forks">
										21
									</a>
								</div>
							
						</div>
					
				</div>
			</div>
		</div>
	</div>


	<div class="ui tabs container">
		<div class="ui tabular menu navbar">
			
				<a class=" item" href="/diogo/gnu-social">
					<i class="octicon octicon-file-text"></i> Files
				</a>
			
			
				<a class="active item" href="/diogo/gnu-social/issues">
					<i class="octicon octicon-issue-opened"></i> Issues <span class="ui blue small label">73</span>
				</a>
			
			
				<a class=" item" href="/diogo/gnu-social/pulls">
					<i class="octicon octicon-git-pull-request"></i> Pull Requests <span class="ui blue small label">3</span>
				</a>
			
			
				<a class=" item" href="/diogo/gnu-social/wiki">
					<i class="octicon octicon-book"></i> Wiki
				</a>
			
			
		</div>
	</div>
	<div class="ui tabs divider"></div>

</div>

	<div class="ui container">
		<div class="navbar">
			<div class="ui compact small menu">
	<a class=" item" href="/diogo/gnu-social/labels">Labels</a>
	<a class=" item" href="/diogo/gnu-social/milestones">Milestones</a>
</div>

			<div class="ui right">
				
					<a class="ui green button" href="/diogo/gnu-social/issues/new">New Issue</a>
				
			</div>
		</div>
		<div class="ui divider"></div>
		
			<div>
				<div class="ui grid">
	
	
		<div class="sixteen wide column title">
	<div class="ui grid">
		<h1 class="twelve wide column">
			<span class="index">#163</span> <span id="issue-title" class="has-emoji">RFC: Restructuring the database</span>
			<div id="edit-title-input" class="ui input" style="display: none">
				<input value="RFC: Restructuring the database">
			</div>
		</h1>
		
	</div>
	
		<div class="ui green large label"><i class="octicon octicon-issue-opened"></i> Open</div>
	

	
		
		<span class="time-desc">
			
				opened <span class="time-since" title="Tue, 30 Jun 2020 18:21:32 UTC">4 months ago</span> by <a href="/someonewithpc">someonewithpc</a>
			
			·
			1 comments
		</span>
	
	<div class="ui divider"></div>
</div>

	

	
	<div class="twelve wide column comment-list">
		<ui class="ui comments">
			<div class="comment">
				<a class="avatar" href="/someonewithpc">
					<img src="https://seccdn.libravatar.org/avatar/89baac3327aebd79156eb67a9db545e6">
				</a>
				<div class="content">
					<div class="ui top attached header">
						<span class="text grey"><a href="/someonewithpc">someonewithpc</a> commented <a href="#issue-65181"><span class="time-since" title="Tue, 30 Jun 2020 18:21:32 UTC">4 months ago</span></a></span>
						<div class="ui right actions">
							
						</div>
					</div>
					<div class="ui attached segment">
						<div class="render-content markdown has-emoji">
							
								<p>I&#39;d like comments on the commits <del><a href="https://notabug.org/diogo/gnu-social/commit/20b0c4a3a6b38b3631fdd00fd967ff973dde0e77" rel="nofollow">20b0c4a3a6</a></del> <a href="https://notabug.org/diogo/gnu-social/commit/a17072af6291d8f56b7f37901caf39d3b048033e" rel="nofollow">a17072af62</a> and <a href="https://notabug.org/diogo/gnu-social/commit/a56d64678b22158cd04ecf35200a975838f1a7a5" rel="nofollow">a56d64678b</a>, on branch v3</p>

							
						</div>
						<div class="raw-content hide">I&#39;d like comments on the commits ~~[20b0c4a3a6](https://notabug.org/diogo/gnu-social/commit/20b0c4a3a6b38b3631fdd00fd967ff973dde0e77)~~ [a17072af62](https://notabug.org/diogo/gnu-social/commit/a17072af6291d8f56b7f37901caf39d3b048033e) and [a56d64678b](https://notabug.org/diogo/gnu-social/commit/a56d64678b22158cd04ecf35200a975838f1a7a5), on branch v3</div>
						<div class="edit-content-zone hide" data-write="issue-65181-write" data-preview="issue-65181-preview" data-update-url="/diogo/gnu-social/issues/163/content" data-context="/diogo/gnu-social"></div>
					</div>
					
				</div>
			</div>

			
				

				
				
					<div class="comment" id="issuecomment-19749">
						<a class="avatar" href="/someonewithpc">
							<img src="https://seccdn.libravatar.org/avatar/89baac3327aebd79156eb67a9db545e6">
						</a>
						<div class="content">
							<div class="ui top attached header">
								<span class="text grey"><a href="/someonewithpc">someonewithpc</a> commented <a href="#issuecomment-19749"><span class="time-since" title="Tue, 30 Jun 2020 21:55:38 UTC">4 months ago</span></a></span>
								<div class="ui right actions">
									
										<div class="item tag">
											
												Collaborator
											
										</div>
									
									
								</div>
							</div>
							<div class="ui attached segment">
								<div class="render-content markdown has-emoji">
									
										<h1>What</h1>

<p>A summary of the changes:</p>

<ol>
<li>Renamed <code>notice</code> to <code>activity</code></li>
<li>Deleted <code>activity.url</code></li>
<li>Deleted <code>avatar.filename</code></li>
<li>Removed all OAuth1 related tables (<code>consumer</code>, <code>nonce</code>, <code>oauth_application{,user}</code>, <code>oauth_token</code>, <code>token</code>)</li>
<li>Removed <code>file.filename</code>, added <code>file.is_local</code>, renamed <code>date</code> to <code>timestamp</code></li>
<li>Removed <code>file_redirection</code></li>
<li>Removed <code>file_thumbnail.{filename,url,url_hash}</code></li>
<li>Renamed <code>subscription</code> to <code>follow</code></li>
<li>Renamed <code>user_group</code> to <code>group</code>, added <code>profile_id</code> as unique key</li>
<li>Removed <code>local_group</code></li>
<li>Renamed <code>location_namespace</code> to <code>location_service</code></li>
<li>Removed <code>login_token</code>, <code>remember_me</code> and <code>session</code></li>
<li>Renamed <code>attention</code> to <code>notification</code></li>
<li>Removed <code>old_school_preferences</code></li>
<li>Removed <code>reply</code></li>
<li>Renamed <code>unavailable_status_network</code> to <code>reserved_nickname</code></li>
<li>Removed <code>schema_version</code></li>
<li>Removed notification settings from <code>user</code> table</li>
<li>Replaced <code>user_im_prefs</code> with <code>user_notification_prefs</code></li>
<li>Removed <code>user_username</code></li>
<li>Changed <code>modified</code> fields to use <code>timestamp</code>s</li>
</ol>

<h1>Why</h1>

<ol>
<li>The <code>notice</code> table had all sorts of activity streams objects</li>
<li>Activities can have more than one url, and this relation is made with the <code>file</code> table already, so this field is not necessary</li>
<li>avatar files can be identified by <code>&#39;id-height_width&#39;</code></li>
<li>We&#39;ll use <a href="https://github.com/authbucket/oauth2-symfony-bundle" rel="nofollow">AuthBucket&#39;s OAuth2</a></li>
<li>Filename will be replaced with it&#39;s hash, the title will have it&#39;s description. <code>is_local</code> used to distinguish local attachments from remote attachments or urls. <code>date</code> was an unix timestamp, from the HTTP query</li>
<li>Superfluous table, final url stored in <code>file</code>, <code>redirection_count</code> irrelevant</li>
<li>As with <code>file</code>, file thumbnails can be identified by <code>&#39;hash-height_width&#39;</code>. <code>url{,_hash}</code> is already in the <code>file</code> table</li>
<li>Subscription makes it sound like a paid comercial product, follow is a more common term for social networks</li>
<li><code>user_group</code> suggests a join table between <code>user</code> and <code>group</code>. A previous bug prevented the used of <code>profile_id</code> as an unique key, but it&#39;s no longer relevant and a <code>profile</code> can be in a <code>group</code> at most once</li>
<li>This table was always used in a join with <code>group</code>. <code>group</code> already has <code>is_local</code></li>
<li>Namespace was a confusing term, but it turns out it was just meant to identify a service an id belongs to, in case another location service is used in the future</li>
<li>Login and session will be handled with Symfony&#39;s implementation. Session will have <a href="https://symfony.com/doc/current/session/database.html#store-sessions-in-a-relational-database-mysql-postgresql" rel="nofollow">a new table</a>, to be implemented when I get there</li>
<li>Just a more standard name</li>
<li>These settings are deprecated, <code>conversation_tree</code> is a plugin</li>
<li>Old table, <code>activity</code> already has a <code>reply_to</code> field (which is indexed)</li>
<li>Very bad name</li>
<li>Handled by Doctrine</li>
<li>Combinatorial explosion of needed fields</li>
<li>See above. This table can have all discrete settings for each type of transport (email, xmpp, sms, etc)</li>
<li>Old table, not used in core. Seemingly used only for the LDAP plugin, which will be implemented in terms of <a href="https://symfony.com/doc/current/security/ldap.html" rel="nofollow">Symfony&#39;s implementation</a></li>
<li>For consistency, we&#39;ll have the ORM handle it with <a href="https://github.com/l3pp4rd/DoctrineExtensions/blob/master/doc/timestampable.md" rel="nofollow">this</a>.</li>
</ol>

<h1>Aditional Questions</h1>

<ul>
<li>Should we keep SMS support? I&#39;m not sure if it&#39;s currently functional and if it&#39;s worth making it so</li>
<li>What to do about repeats of deleted activities? I think we should recurse on the <code>repeat_of</code> field and display the content we find there, not make a copy. This way deleting something will actually delete it (on this instance)</li>
</ul>

									
								</div>
								<div class="raw-content hide"># What

A summary of the changes:
 1. Renamed `notice` to `activity`
 1. Deleted `activity.url`
 1. Deleted `avatar.filename`
 1. Removed all OAuth1 related tables (`consumer`, `nonce`, `oauth_application{,user}`, `oauth_token`, `token`)
 1. Removed `file.filename`, added `file.is_local`, renamed `date` to `timestamp`
 1. Removed `file_redirection`
 1. Removed `file_thumbnail.{filename,url,url_hash}`
 1. Renamed `subscription` to `follow`
 1. Renamed `user_group` to `group`, added `profile_id` as unique key
 1. Removed `local_group`
 1. Renamed `location_namespace` to `location_service`
 1. Removed `login_token`, `remember_me` and `session`
 1. Renamed `attention` to `notification`
 1. Removed `old_school_preferences`
 1. Removed `reply`
 1. Renamed `unavailable_status_network` to `reserved_nickname`
 1. Removed `schema_version`
 1. Removed notification settings from `user` table
 1. Replaced `user_im_prefs` with `user_notification_prefs`
 1. Removed `user_username`
 1. Changed `modified` fields to use `timestamp`s

# Why

 1. The `notice` table had all sorts of activity streams objects
 1. Activities can have more than one url, and this relation is made with the `file` table already, so this field is not necessary
 1. avatar files can be identified by `&#39;id-height_width&#39;`
 1. We&#39;ll use [AuthBucket&#39;s OAuth2](https://github.com/authbucket/oauth2-symfony-bundle)
 1. Filename will be replaced with it&#39;s hash, the title will have it&#39;s description. `is_local` used to distinguish local attachments from remote attachments or urls. `date` was an unix timestamp, from the HTTP query
 1. Superfluous table, final url stored in `file`, `redirection_count` irrelevant
 1. As with `file`, file thumbnails can be identified by `&#39;hash-height_width&#39;`. `url{,_hash}` is already in the `file` table
 1. Subscription makes it sound like a paid comercial product, follow is a more common term for social networks
 1. `user_group` suggests a join table between `user` and `group`. A previous bug prevented the used of `profile_id` as an unique key, but it&#39;s no longer relevant and a `profile` can be in a `group` at most once
 1. This table was always used in a join with `group`. `group` already has `is_local`
 1. Namespace was a confusing term, but it turns out it was just meant to identify a service an id belongs to, in case another location service is used in the future
 1. Login and session will be handled with Symfony&#39;s implementation. Session will have [a new table](https://symfony.com/doc/current/session/database.html#store-sessions-in-a-relational-database-mysql-postgresql), to be implemented when I get there
 1. Just a more standard name
 1. These settings are deprecated, `conversation_tree` is a plugin
 1. Old table, `activity` already has a `reply_to` field (which is indexed)
 1. Very bad name
 1. Handled by Doctrine
 1. Combinatorial explosion of needed fields
 1. See above. This table can have all discrete settings for each type of transport (email, xmpp, sms, etc)
 1. Old table, not used in core. Seemingly used only for the LDAP plugin, which will be implemented in terms of [Symfony&#39;s implementation](https://symfony.com/doc/current/security/ldap.html)
 1. For consistency, we&#39;ll have the ORM handle it with [this](https://github.com/l3pp4rd/DoctrineExtensions/blob/master/doc/timestampable.md).

# Aditional Questions

 - Should we keep SMS support? I&#39;m not sure if it&#39;s currently functional and if it&#39;s worth making it so
 - What to do about repeats of deleted activities? I think we should recurse on the `repeat_of` field and display the content we find there, not make a copy. This way deleting something will actually delete it (on this instance)</div>
								<div class="edit-content-zone hide" data-write="issuecomment-19749-write" data-preview="issuecomment-19749-preview" data-update-url="/diogo/gnu-social/comments/19749" data-context="/diogo/gnu-social"></div>
							</div>
							
						</div>
					</div>
				

			

			

			
				<div class="ui warning message">
					<a href="/user/login?redirect_to=/diogo/gnu-social/issues/163">Sign in</a> to join this conversation.
				</div>
			
		</ui>
	</div>

	<div class="four wide column">
		<div class="ui segment metas">
			<div class="ui disabled floating jump select-label dropdown">
				<span class="text">
					<strong>Labels</strong>
					<span class="octicon octicon-gear"></span>
				</span>
				<div class="filter menu" data-action="update" data-update-url="/diogo/gnu-social/issues/163/label">
					<div class="no-select item">Clear labels</div>
					
						<a class=" item" href="#" data-id="1564" data-id-selector="#label_1564"><span class="octicon "></span><span class="label color" style="background-color: #fbca04"></span> bounty</a>
					
						<a class=" item" href="#" data-id="1483" data-id-selector="#label_1483"><span class="octicon "></span><span class="label color" style="background-color: #ee0701"></span> bug</a>
					
						<a class=" item" href="#" data-id="1484" data-id-selector="#label_1484"><span class="octicon "></span><span class="label color" style="background-color: #cccccc"></span> duplicate</a>
					
						<a class=" item" href="#" data-id="1485" data-id-selector="#label_1485"><span class="octicon "></span><span class="label color" style="background-color: #84b6eb"></span> enhancement</a>
					
						<a class=" item" href="#" data-id="1486" data-id-selector="#label_1486"><span class="octicon "></span><span class="label color" style="background-color: #128a0c"></span> help wanted</a>
					
						<a class=" item" href="#" data-id="1487" data-id-selector="#label_1487"><span class="octicon "></span><span class="label color" style="background-color: #e6e6e6"></span> invalid</a>
					
						<a class=" item" href="#" data-id="1488" data-id-selector="#label_1488"><span class="octicon "></span><span class="label color" style="background-color: #cc317c"></span> question</a>
					
						<a class="checked item" href="#" data-id="1565" data-id-selector="#label_1565"><span class="octicon octicon-check"></span><span class="label color" style="background-color: #d4c5f9"></span> RFC</a>
					
						<a class=" item" href="#" data-id="1841" data-id-selector="#label_1841"><span class="octicon "></span><span class="label color" style="background-color: #0052cc"></span> v3</a>
					
						<a class=" item" href="#" data-id="1489" data-id-selector="#label_1489"><span class="octicon "></span><span class="label color" style="background-color: #ffffff"></span> wontfix</a>
					
				</div>
			</div>
			<div class="ui labels list">
				<span class="no-select item hide">No Label</span>
				
					<div class="item">
						<a class="ui label hide" id="label_1564" href="/diogo/gnu-social/issues?labels=1564" style="color: #000; background-color: #fbca04">bounty</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1483" href="/diogo/gnu-social/issues?labels=1483" style="color: #fff; background-color: #ee0701">bug</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1484" href="/diogo/gnu-social/issues?labels=1484" style="color: #000; background-color: #cccccc">duplicate</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1485" href="/diogo/gnu-social/issues?labels=1485" style="color: #000; background-color: #84b6eb">enhancement</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1486" href="/diogo/gnu-social/issues?labels=1486" style="color: #fff; background-color: #128a0c">help wanted</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1487" href="/diogo/gnu-social/issues?labels=1487" style="color: #000; background-color: #e6e6e6">invalid</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1488" href="/diogo/gnu-social/issues?labels=1488" style="color: #fff; background-color: #cc317c">question</a>
					</div>

				
					<div class="item">
						<a class="ui label " id="label_1565" href="/diogo/gnu-social/issues?labels=1565" style="color: #000; background-color: #d4c5f9">RFC</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1841" href="/diogo/gnu-social/issues?labels=1841" style="color: #fff; background-color: #0052cc">v3</a>
					</div>

				
					<div class="item">
						<a class="ui label hide" id="label_1489" href="/diogo/gnu-social/issues?labels=1489" style="color: #000; background-color: #ffffff">wontfix</a>
					</div>

				
			</div>

			<div class="ui divider"></div>

			<div class="ui disabled floating jump select-milestone dropdown">
				<span class="text">
					<strong>Milestone</strong>
					<span class="octicon octicon-gear"></span>
				</span>
				<div class="menu" data-action="update" data-update-url="/diogo/gnu-social/issues/163/milestone">
					<div class="no-select item">Clear milestone</div>
					
					
				</div>
			</div>
			<div class="ui select-milestone list">
				<span class="no-select item ">No Milestone</span>
				<div class="selected">
					
				</div>
			</div>

			<div class="ui divider"></div>

			<input id="assignee_id" name="assignee_id" type="hidden" value="">
			<div class="ui disabled floating jump select-assignee dropdown">
				<span class="text">
					<strong>Assignee</strong>
					<span class="octicon octicon-gear"></span>
				</span>
				<div class="menu" data-action="update" data-update-url="/diogo/gnu-social/issues/163/assignee">
					<div class="no-select item">Clear assignee</div>
					
				</div>
			</div>
			<div class="ui select-assignee list">
				<span class="no-select item hide">No assignee</span>
				<div class="selected">
					
						<a class="item" href="/diogo/gnu-social/issues?assignee=21260"><img class="ui avatar image" src="https://seccdn.libravatar.org/avatar/be64a3cf684f74eecd530b6d69cde332"> XRevan86</a>
					
				</div>
			</div>

			<div class="ui divider"></div>

			<div class="ui participants">
				<span class="text"><strong>1 Participants</strong></span>
				<div>
					
						<a href="/someonewithpc">
							<img class="ui avatar image poping up" src="https://seccdn.libravatar.org/avatar/89baac3327aebd79156eb67a9db545e6" data-content="someonewithpc" data-position="top center" data-variation="small inverted">
						</a>
					
				</div>
			</div>
		</div>
	</div>
</div>

<div class="hide" id="edit-content-form">
	<div class="ui comment form">
		<div class="ui top attached tabular menu">
			<a class="active write item">Write</a>
			<a class="preview item" data-url="/api/v1/markdown" data-context="/diogo/gnu-social">Preview</a>
		</div>
		<div class="ui bottom attached active write tab segment">
			<textarea tabindex="1" id="content" name="content"></textarea>
		</div>
		<div class="ui bottom attached tab preview segment markdown">
			Loading...
		</div>
		<div class="text right edit buttons">
			<div class="ui basic blue cancel button" tabindex="3">Cancel</div>
			<div class="ui green save button" tabindex="2">Save</div>
		</div>
	</div>
</div>

<div class="hide" id="no-content">
	<span class="no-content">There is no content yet.</span>
</div>

			</div>
		
	</div>
</div>

	</div>
	<footer>
		<div class="ui container">
			<div class="ui left">



				<a href="/tos">Terms of Service</a>
				&bull;
				<a href="/about">About us</a>
				&bull;
				<a href="/outages">Outages</a>
				&bull;
				<a href="/hp/gogs/issues">Report a problem</a>
				&bull;
				<a href="/assets/librejs/librejs.html" data-jslicense="1">Javascript licenses</a>
				&bull;
				<a href="/fingerprints">SSH Fingerprints</a>



			</div>
			<div class="ui right links">
				
				<div class="ui language bottom floating slide up dropdown link item">
					<i class="world icon"></i>
					<div class="text">English</div>
					<div class="menu">
						
							<a class="item active selected" href="#">English</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=zh-CN">简体中文</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=zh-HK">繁體中文（香港）</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=zh-TW">繁體中文（臺灣）</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=de-DE">Deutsch</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=fr-FR">français</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=nl-NL">Nederlands</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=lv-LV">latviešu</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=ru-RU">русский</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=ja-JP">日本語</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=es-ES">español</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=pt-BR">português do Brasil</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=pl-PL">polski</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=bg-BG">български</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=it-IT">italiano</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=fi-FI">suomi</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=tr-TR">Türkçe</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=cs-CZ">čeština</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=sr-SP">српски</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=sv-SE">svenska</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=ko-KR">한국어</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=gl-ES">galego</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=uk-UA">українська</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=en-GB">English (United Kingdom)</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=hu-HU">Magyar</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=sk-SK">Slovenčina</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=id-ID">Indonesian</a>
						
							<a class="item " href="/diogo/gnu-social/issues/163?lang=fa-IR">Persian</a>
						
					</div>
				</div>



				
			</div>
		</div>
	</footer>
</body>



	<link rel="stylesheet" href="/plugins/highlight-9.6.0/github.css">
	<script src="/plugins/highlight-9.6.0/highlight.pack.js"></script>




	<link rel="stylesheet" href="/plugins/dropzone-4.2.0/dropzone.css">
	<script src="/plugins/dropzone-4.2.0/dropzone.js"></script>

<script src="/js/libs/emojify-1.1.0.min.js"></script>
<script src="/js/libs/clipboard-1.5.9.min.js"></script>
	
</html>

